﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;

/// <summary>
/// Summary description for DAL
/// </summary>
public class DAL
{
    public DataSet PD(string ID)
    {
        using (SqlConnection con = new SqlConnection(CString.ConnectionString))
        {
            string qul = "SELECT UserID, Name, eMailid, Address FROM Regester WHERE UserID ='" + ID + "'";
            SqlCommand com = new SqlCommand(qul, con);
            con.Open();
            com.ExecuteNonQuery();
            con.Close();
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(com);
            da.Fill(ds);
            return ds;
        }
    }
}